<html><head><title>create table</title><meta name="HandheldFriendly" content="True"></head><body>Create a tables and optionally integrity constraints.<br><br><b>create</b> <b>table</b> [database.[owner].]table (column datatype [<b>default</b> { constant_expression | <b>user</b> | <b>null</b> }] {[{<b>identity</b> | <b>null</b> | <b>not</b> <b>null</b>}] [<b>off</b> <b>row</b> | [<b>on</b> <b>row</b>[(value)]]] | [<a href="q307335.html">simple constraint definition</a>]}... | <a href="q307334.html">complex constraint definition</a> [ {,{ next_column | <a href="q307334.html">complex constraint definition</a>}}...]) [<b>lock</b> {<b>datarows</b> | <b>datapages</b> | <b>allpages</b>}] [<b>with</b> {<b>max_rows_per_page</b> =  value, <b>exp_row_size</b> = value, <b>reservepagegap</b> = value, <b>identity_gap</b> = value}] [<b>on</b> segment] [[<b>external</b> <b>table</b>] <b>at</b> "server.database.owner.{table | view | procedure}[;db2_extra]"</body></html>